Calculation Spreadsheet Archive

Changed

Last updated: 3 weeks ago

E-GGRT currently reflects the rules deferring reporting of inputs to emission equations for direct emitters. In August 2011, EPA deferred the reporting deadline for inputs to equations until either March 31, 2013 or March 31, 2015 to allow time to fully evaluate the potential impact from the release of this data. The inputs to equations whose reporting deadline was deferred until 2013 are listed in Table A-6 of subpart A of the GHG reporting rule. e-GGRT webforms and reporting forms have been modified to include input to equations that are no longer deferred. As a result some optional calculation spreadsheets that were use in prior reporting years have been subsumed by webforms or reporting forms and are no longer in use.

In case you would like to do these calculations yourself or double check e-GGRT's calculations we have provided an archive of obsolete calculations spreadsheets below:

SubpartCalculation Spreadsheets 
(click to download)
C - Combustion

Equation C-1, C-8 Calculation Spreadsheet for RY2014 to RY2023.xls

Equation C-1a, C-8a Calculation Spreadsheet for RY2014 to RY2023.xls

Equation C-1b, C-8b Calculation Spreadsheet for RY2014 to RY2023.xls

Equation C-2a, C-2b, C-9a Calculation Spreadsheet for RY2014 to RY2023.xls

Equation C-2c, C-9b Calculation Spreadsheet for RY2014 to RY2023.xls

Equation C-3, C-8 Calculation Spreadsheet for RY2014 to RY2023.xls

Equation C-4, C-8 Calculation Spreadsheet for RY2014 to RY2023.xls

Equation C-5, C-8 Calculation Spreadsheet for RY2014 to RY2023.xls

Equation C-10 Calculation Spreadsheet for RY2014 to RY2023.xls

Equation C-11 Calculation Spreadsheet.xls

I - Electronics Manufacturing

Subpart I Calculation Tool for RY2013 and earlier.xlsx

Subpart I Calculation Tool for RY2014 and RY2015.xlsx

Subpart I Calculation Tool for RY2016-2023.xlsx

L - Fluorinated Gas Production

Subpart L Calculation Spreadsheets - Mass Balance Equations-RY2012-2023.xls

Subpart L Calculation Spreadsheets - Emission Factor Equations- RY2012-2023.xls

Subpart L Calculation Spreadsheet - Summarize Process Level CO2e by f-GHG-RY2012-2023.xls

W- Petroleum and Natural Gas 

Subpart W Calculation Tool for RY11 and RY12.zip

Subpart W Calculation Tool for RY13 and RY14.zip

Subpart W Calculation Tool for RY15 and Later Revised 03142016.zip

Subpart W Calculation Tool for RY16 and Later.xlsx

DD - Use of Electric Transmission and Distribution EquipmentSubpart DD Calculation Spreadsheet.xls
SS - Electrical Equipment Manufacturer or RefurbishmentEquation SS-1 Calculation Spreadsheet (PFC).xls
SS - Electrical Equipment Manufacturer or RefurbishmentEquation SS-1 Calculation Spreadsheet (SF6).xls
SS - Electrical Equipment Manufacturer or RefurbishmentEquation SS-5 Calculation Spreadsheet.xls
SS - Electrical Equipment Manufacturer or RefurbishmentEquation SS-6 Calculation Spreadsheet.xls
TT - Industrial LandfillsEquation TT-3, TT-4a, TT-4b Calculation Spreadsheet.xls